FO_MergeTable_Definitions
Table used to establish alias/cross reference of data elements for merge process since same data element might be posted to multiple tables.
| Field | Type | Notes |
|---|---|---|
|
MergeTables_ID |
int |
ID field, a counter. Unique |
|
Active |
bit |
Bit flag to indicate if this record is active. Enter 0 or 1 0 = inactive (FALSE) 1 = active (ACTIVE) |
|
TableName |
varchar(50) |
Enter a valid database table name. |
|
PT_ID |
varchar(50) |
Enter a valid column name for patient row identifier. Do not enter a column name that is a table’s primary key, for example, for the FO_Acc_Pts or FO_Patients tables. |
|
FOID |
varchar(50) |
Enter a valid column name for FOID. |
|
MRN |
varchar(50) |
Enter a valid column name for MRN, medical record number. |
|
MRNHID |
varchar(50) |
Enter a valid column name for MRN/Facility ID. |
|
Acct |
varchar(50) |
Enter a valid column name for account. |
|
EpisodeID |
varchar(50) |
Enter a valid column name for episode ID. Do not enter a column name that is a table’s primary key, for example, for the FO_Episodes table. |
|
LIS_Episode |
varchar(50) |
Enter a valid column name for lab system episode number. |
|
SSN |
varchar(50) |
Enter a valid column name for social security number. |
|
PtName |
varchar(50) |
Enter a valid column name for patient name. |
|
PtDOB |
varchar(50) |
Enter a valid column name for patient date of birth. |
|
PtGender |
varchar(50) |
Enter a valid column name for patient gender. |
|
UniqueAcc |
varchar(50) |
Enter a valid column name for unique accession number. |
|
Accession |
varchar(50) |
Enter a valid column name for FAST accession number. |
|
LabAcc |
varchar(50) |
Enter a valid column name for lab accession number. |
|
PIDX |
varchar(50) |
Enter a valid column name for lab system internal patient identifier. |
|
ORDX |
varchar(50) |
Enter a valid column name for lab system internal order identifier. |
|
FacilityID |
varchar(50) |
Enter a valid column name for facility ID. |
|
CreateDate |
datetime |
Date record was created. Informational |
|
EditDate |
datetime |
Date record was last edited. Informational |
|
Last_Name |
varchar(50) |
Enter a valid column name for patient last name. |
|
First_Name |
varchar(50) |
Enter a valid column name for patient first name. |
|
MI |
varchar(50) |
Enter a valid column name for patient middle initial. |